Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 276 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 28.0 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Text | 2 |
|---|---|
| Numeric | 10 |
All Grades is highly overall correlated with Total Students and 3 other fields | High correlation |
Total Students is highly overall correlated with All Grades and 3 other fields | High correlation |
Primary is highly overall correlated with All Grades and 1 other fields | High correlation |
Secondary is highly overall correlated with All Grades and 2 other fields | High correlation |
Others-% is highly overall correlated with All Grades and 2 other fields | High correlation |
Tests Taken is highly overall correlated with Total Students and 1 other fields | High correlation |
% Score 3-5 is highly overall correlated with Total Students and 1 other fields | High correlation |
District Name_x has unique values | Unique |
District Code has unique values | Unique |
District Name_y has unique values | Unique |
All Grades has 64 (23.2%) zeros | Zeros |
Primary has 206 (74.6%) zeros | Zeros |
Secondary has 98 (35.5%) zeros | Zeros |
High has 149 (54.0%) zeros | Zeros |
Others-% has 64 (23.2%) zeros | Zeros |
Tests Taken has 59 (21.4%) zeros | Zeros |
% Score 1-2 has 79 (28.6%) zeros | Zeros |
% Score 3-5 has 82 (29.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-02 22:22:45.443794 |
|---|---|
| Analysis finished | 2023-07-02 22:22:52.741872 |
| Duration | 7.3 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
District Name_x
Text
UNIQUE
| Distinct | 276 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 KiB |
Length
| Max length | 61 |
|---|---|
| Median length | 56 |
| Mean length | 16.474638 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4547 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 276 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Abington |
|---|---|
| 2nd row | Academy Of the Pacific Rim Charter Public (District) |
| 3rd row | Acton-Boxborough |
| 4th row | Advanced Math and Science Academy Charter (District) |
| 5th row | Agawam |
| Value | Count | Frequency (%) |
| district | 34 | 6.2% |
| regional | 28 | 5.1% |
| charter | 27 | 5.0% |
| vocational | 22 | 4.0% |
| technical | 21 | 3.9% |
| school | 16 | 2.9% |
| academy | 10 | 1.8% |
| public | 7 | 1.3% |
| north | 7 | 1.3% |
| of | 6 | 1.1% |
| Other values (304) | 367 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 380 | 8.4% |
| o | 350 | 7.7% |
| a | 327 | 7.2% |
| t | 317 | 7.0% |
| r | 306 | 6.7% |
| i | 289 | 6.4% |
| n | 271 | 6.0% |
| 269 | 5.9% | |
| l | 261 | 5.7% |
| c | 189 | 4.2% |
| Other values (45) | 1588 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3616 | |
| Uppercase Letter | 576 | 12.7% |
| Space Separator | 269 | 5.9% |
| Open Punctuation | 28 | 0.6% |
| Close Punctuation | 28 | 0.6% |
| Dash Punctuation | 27 | 0.6% |
| Other Punctuation | 3 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 380 | |
| o | 350 | |
| a | 327 | |
| t | 317 | |
| r | 306 | |
| i | 289 | 8.0% |
| n | 271 | 7.5% |
| l | 261 | 7.2% |
| c | 189 | 5.2% |
| h | 172 | 4.8% |
| Other values (15) | 754 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 62 | 10.8% |
| C | 57 | 9.9% |
| R | 45 | 7.8% |
| D | 45 | 7.8% |
| M | 37 | 6.4% |
| A | 36 | 6.2% |
| B | 35 | 6.1% |
| W | 33 | 5.7% |
| T | 33 | 5.7% |
| V | 30 | 5.2% |
| Other values (13) | 163 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1 | |
| ' | 1 | |
| . | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 269 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 28 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 28 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 27 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4192 | |
| Common | 355 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 380 | 9.1% |
| o | 350 | 8.3% |
| a | 327 | 7.8% |
| t | 317 | 7.6% |
| r | 306 | 7.3% |
| i | 289 | 6.9% |
| n | 271 | 6.5% |
| l | 261 | 6.2% |
| c | 189 | 4.5% |
| h | 172 | 4.1% |
| Other values (38) | 1330 |
Common
| Value | Count | Frequency (%) |
| 269 | ||
| ( | 28 | 7.9% |
| ) | 28 | 7.9% |
| - | 27 | 7.6% |
| : | 1 | 0.3% |
| ' | 1 | 0.3% |
| . | 1 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4547 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 380 | 8.4% |
| o | 350 | 7.7% |
| a | 327 | 7.2% |
| t | 317 | 7.0% |
| r | 306 | 6.7% |
| i | 289 | 6.4% |
| n | 271 | 6.0% |
| 269 | 5.9% | |
| l | 261 | 5.7% |
| c | 189 | 4.2% |
| Other values (45) | 1588 |
District Code
Real number (ℝ)
UNIQUE
| Distinct | 276 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3935615.9 |
| Minimum | 0 |
|---|---|
| Maximum | 39020000 |
| Zeros | 1 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 257500 |
| Q1 | 1477500 |
| median | 2845000 |
| Q3 | 6227500 |
| 95-th percentile | 8512500 |
| Maximum | 39020000 |
| Range | 39020000 |
| Interquartile range (IQR) | 4750000 |
Descriptive statistics
| Standard deviation | 4320424.3 |
|---|---|
| Coefficient of variation (CV) | 1.0977759 |
| Kurtosis | 33.368319 |
| Mean | 3935615.9 |
| Median Absolute Deviation (MAD) | 1850000 |
| Skewness | 4.7329688 |
| Sum | 1.08623 × 109 |
| Variance | 1.8666066 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10000 | 1 | 0.4% |
| 2200000 | 1 | 0.4% |
| 2290000 | 1 | 0.4% |
| 8600000 | 1 | 0.4% |
| 2270000 | 1 | 0.4% |
| 2260000 | 1 | 0.4% |
| 7400000 | 1 | 0.4% |
| 8550000 | 1 | 0.4% |
| 2190000 | 1 | 0.4% |
| 2170000 | 1 | 0.4% |
| Other values (266) | 266 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 10000 | 1 | |
| 50000 | 1 | |
| 70000 | 1 | |
| 90000 | 1 | |
| 100000 | 1 | |
| 140000 | 1 | |
| 160000 | 1 | |
| 170000 | 1 | |
| 180000 | 1 |
| Value | Count | Frequency (%) |
| 39020000 | 1 | |
| 35060000 | 1 | |
| 35030000 | 1 | |
| 9100000 | 1 | |
| 8850000 | 1 | |
| 8790000 | 1 | |
| 8780000 | 1 | |
| 8760000 | 1 | |
| 8730000 | 1 | |
| 8720000 | 1 |
All Grades
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 188 |
|---|---|
| Distinct (%) | 68.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 839.02174 |
| Minimum | 0 |
|---|---|
| Maximum | 121772 |
| Zeros | 64 |
| Zeros (%) | 23.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 199 |
| Q3 | 567.5 |
| 95-th percentile | 1526.75 |
| Maximum | 121772 |
| Range | 121772 |
| Interquartile range (IQR) | 562.5 |
Descriptive statistics
| Standard deviation | 7326.4694 |
|---|---|
| Coefficient of variation (CV) | 8.7321568 |
| Kurtosis | 272.86172 |
| Mean | 839.02174 |
| Median Absolute Deviation (MAD) | 199 |
| Skewness | 16.472944 |
| Sum | 231570 |
| Variance | 53677154 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 64 | 23.2% |
| 49 | 4 | 1.4% |
| 6 | 3 | 1.1% |
| 119 | 3 | 1.1% |
| 179 | 2 | 0.7% |
| 1 | 2 | 0.7% |
| 28 | 2 | 0.7% |
| 113 | 2 | 0.7% |
| 120 | 2 | 0.7% |
| 13 | 2 | 0.7% |
| Other values (178) | 190 |
| Value | Count | Frequency (%) |
| 0 | 64 | |
| 1 | 2 | 0.7% |
| 2 | 2 | 0.7% |
| 5 | 2 | 0.7% |
| 6 | 3 | 1.1% |
| 8 | 1 | 0.4% |
| 13 | 2 | 0.7% |
| 15 | 1 | 0.4% |
| 16 | 1 | 0.4% |
| 18 | 1 | 0.4% |
| Value | Count | Frequency (%) |
| 121772 | 1 | |
| 3925 | 1 | |
| 3129 | 1 | |
| 2716 | 1 | |
| 2062 | 1 | |
| 2007 | 1 | |
| 1939 | 1 | |
| 1885 | 1 | |
| 1873 | 1 | |
| 1835 | 1 |
Total Students
Real number (ℝ)
HIGH CORRELATION
| Distinct | 267 |
|---|---|
| Distinct (%) | 96.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3912.1884 |
| Minimum | 0 |
|---|---|
| Maximum | 557504 |
| Zeros | 2 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 192.75 |
| Q1 | 848.5 |
| median | 1540 |
| Q3 | 2616.25 |
| 95-th percentile | 4585.75 |
| Maximum | 557504 |
| Range | 557504 |
| Interquartile range (IQR) | 1767.75 |
Descriptive statistics
| Standard deviation | 33478.353 |
|---|---|
| Coefficient of variation (CV) | 8.5574491 |
| Kurtosis | 274.83933 |
| Mean | 3912.1884 |
| Median Absolute Deviation (MAD) | 848 |
| Skewness | 16.561189 |
| Sum | 1079764 |
| Variance | 1.1208001 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1844 | 2 | 0.7% |
| 951 | 2 | 0.7% |
| 862 | 2 | 0.7% |
| 1311 | 2 | 0.7% |
| 141 | 2 | 0.7% |
| 692 | 2 | 0.7% |
| 2517 | 2 | 0.7% |
| 2034 | 2 | 0.7% |
| 0 | 2 | 0.7% |
| 989 | 1 | 0.4% |
| Other values (257) | 257 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 22 | 1 | |
| 23 | 1 | |
| 27 | 1 | |
| 36 | 1 | |
| 39 | 1 | |
| 87 | 1 | |
| 130 | 1 | |
| 141 | 2 | |
| 153 | 1 |
| Value | Count | Frequency (%) |
| 557504 | 1 | |
| 10247 | 1 | |
| 9217 | 1 | |
| 7797 | 1 | |
| 7370 | 1 | |
| 7055 | 1 | |
| 5985 | 1 | |
| 5794 | 1 | |
| 5681 | 1 | |
| 5102 | 1 |
Primary
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 71 |
|---|---|
| Distinct (%) | 25.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 238.62319 |
| Minimum | 0 |
|---|---|
| Maximum | 35619 |
| Zeros | 206 |
| Zeros (%) | 74.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 9.5 |
| 95-th percentile | 645.5 |
| Maximum | 35619 |
| Range | 35619 |
| Interquartile range (IQR) | 9.5 |
Descriptive statistics
| Standard deviation | 2152.5636 |
|---|---|
| Coefficient of variation (CV) | 9.0207647 |
| Kurtosis | 268.21827 |
| Mean | 238.62319 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.267065 |
| Sum | 65860 |
| Variance | 4633530.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 206 | |
| 360 | 1 | 0.4% |
| 585 | 1 | 0.4% |
| 484 | 1 | 0.4% |
| 824 | 1 | 0.4% |
| 471 | 1 | 0.4% |
| 584 | 1 | 0.4% |
| 248 | 1 | 0.4% |
| 178 | 1 | 0.4% |
| 227 | 1 | 0.4% |
| Other values (61) | 61 | 22.1% |
| Value | Count | Frequency (%) |
| 0 | 206 | |
| 6 | 1 | 0.4% |
| 20 | 1 | 0.4% |
| 26 | 1 | 0.4% |
| 44 | 1 | 0.4% |
| 73 | 1 | 0.4% |
| 82 | 1 | 0.4% |
| 92 | 1 | 0.4% |
| 119 | 1 | 0.4% |
| 140 | 1 | 0.4% |
| Value | Count | Frequency (%) |
| 35619 | 1 | |
| 1734 | 1 | |
| 1404 | 1 | |
| 1298 | 1 | |
| 1110 | 1 | |
| 1014 | 1 | |
| 970 | 1 | |
| 882 | 1 | |
| 871 | 1 | |
| 824 | 1 |
Secondary
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 161 |
|---|---|
| Distinct (%) | 58.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 569.52536 |
| Minimum | 0 |
|---|---|
| Maximum | 81769 |
| Zeros | 98 |
| Zeros (%) | 35.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 142.5 |
| Q3 | 413.25 |
| 95-th percentile | 1016.75 |
| Maximum | 81769 |
| Range | 81769 |
| Interquartile range (IQR) | 413.25 |
Descriptive statistics
| Standard deviation | 4919.0766 |
|---|---|
| Coefficient of variation (CV) | 8.637151 |
| Kurtosis | 272.91152 |
| Mean | 569.52536 |
| Median Absolute Deviation (MAD) | 142.5 |
| Skewness | 16.47499 |
| Sum | 157189 |
| Variance | 24197314 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 98 | |
| 152 | 4 | 1.4% |
| 49 | 3 | 1.1% |
| 285 | 2 | 0.7% |
| 240 | 2 | 0.7% |
| 92 | 2 | 0.7% |
| 111 | 2 | 0.7% |
| 575 | 2 | 0.7% |
| 257 | 2 | 0.7% |
| 345 | 2 | 0.7% |
| Other values (151) | 157 |
| Value | Count | Frequency (%) |
| 0 | 98 | |
| 6 | 1 | 0.4% |
| 13 | 1 | 0.4% |
| 16 | 1 | 0.4% |
| 26 | 1 | 0.4% |
| 31 | 1 | 0.4% |
| 33 | 1 | 0.4% |
| 49 | 3 | 1.1% |
| 52 | 1 | 0.4% |
| 53 | 1 | 0.4% |
| Value | Count | Frequency (%) |
| 81769 | 1 | |
| 2133 | 1 | |
| 1978 | 1 | |
| 1788 | 1 | |
| 1712 | 1 | |
| 1580 | 1 | |
| 1447 | 1 | |
| 1289 | 1 | |
| 1142 | 1 | |
| 1080 | 1 |
High
Real number (ℝ)
ZEROS
| Distinct | 64 |
|---|---|
| Distinct (%) | 23.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.873188 |
| Minimum | 0 |
|---|---|
| Maximum | 4384 |
| Zeros | 149 |
| Zeros (%) | 54.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 19.25 |
| 95-th percentile | 75.5 |
| Maximum | 4384 |
| Range | 4384 |
| Interquartile range (IQR) | 19.25 |
Descriptive statistics
| Standard deviation | 264.59626 |
|---|---|
| Coefficient of variation (CV) | 8.5704222 |
| Kurtosis | 269.24791 |
| Mean | 30.873188 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.313311 |
| Sum | 8521 |
| Variance | 70011.18 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 149 | |
| 1 | 10 | 3.6% |
| 18 | 6 | 2.2% |
| 5 | 5 | 1.8% |
| 2 | 5 | 1.8% |
| 32 | 5 | 1.8% |
| 16 | 4 | 1.4% |
| 12 | 4 | 1.4% |
| 13 | 4 | 1.4% |
| 45 | 3 | 1.1% |
| Other values (54) | 81 |
| Value | Count | Frequency (%) |
| 0 | 149 | |
| 1 | 10 | 3.6% |
| 2 | 5 | 1.8% |
| 5 | 5 | 1.8% |
| 6 | 3 | 1.1% |
| 7 | 1 | 0.4% |
| 8 | 3 | 1.1% |
| 9 | 2 | 0.7% |
| 10 | 3 | 1.1% |
| 11 | 3 | 1.1% |
| Value | Count | Frequency (%) |
| 4384 | 1 | |
| 252 | 1 | |
| 151 | 1 | |
| 141 | 1 | |
| 119 | 1 | |
| 111 | 1 | |
| 103 | 1 | |
| 95 | 1 | |
| 91 | 1 | |
| 90 | 1 |
Others-%
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 213 |
|---|---|
| Distinct (%) | 77.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.280708 |
| Minimum | 0 |
|---|---|
| Maximum | 84.380952 |
| Zeros | 64 |
| Zeros (%) | 23.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.42940638 |
| median | 14.709841 |
| Q3 | 31.680478 |
| 95-th percentile | 65.760806 |
| Maximum | 84.380952 |
| Range | 84.380952 |
| Interquartile range (IQR) | 31.251072 |
Descriptive statistics
| Standard deviation | 21.359084 |
|---|---|
| Coefficient of variation (CV) | 1.0531725 |
| Kurtosis | -0.098469549 |
| Mean | 20.280708 |
| Median Absolute Deviation (MAD) | 14.709841 |
| Skewness | 0.94151802 |
| Sum | 5597.4754 |
| Variance | 456.21049 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 64 | 23.2% |
| 22.92051756 | 1 | 0.4% |
| 4.238921002 | 1 | 0.4% |
| 2.645788337 | 1 | 0.4% |
| 23.57343312 | 1 | 0.4% |
| 72.57963773 | 1 | 0.4% |
| 5.652759085 | 1 | 0.4% |
| 29.72440945 | 1 | 0.4% |
| 70.06903353 | 1 | 0.4% |
| 25.18555171 | 1 | 0.4% |
| Other values (203) | 203 |
| Value | Count | Frequency (%) |
| 0 | 64 | |
| 0.03620564808 | 1 | 0.4% |
| 0.08333333333 | 1 | 0.4% |
| 0.1453065969 | 1 | 0.4% |
| 0.2029769959 | 1 | 0.4% |
| 0.396039604 | 1 | 0.4% |
| 0.4405286344 | 1 | 0.4% |
| 0.5952380952 | 1 | 0.4% |
| 0.6684771255 | 1 | 0.4% |
| 0.6860158311 | 1 | 0.4% |
| Value | Count | Frequency (%) |
| 84.38095238 | 1 | |
| 76.80067002 | 1 | |
| 72.76887872 | 1 | |
| 72.57963773 | 1 | |
| 72.0276873 | 1 | |
| 71.28982129 | 1 | |
| 70.06903353 | 1 | |
| 69.59798995 | 1 | |
| 69.35558646 | 1 | |
| 69.31092437 | 1 |
District Name_y
Text
UNIQUE
| Distinct | 276 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 KiB |
Length
| Max length | 61 |
|---|---|
| Median length | 56 |
| Mean length | 16.474638 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4547 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 276 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Abington |
|---|---|
| 2nd row | Academy Of the Pacific Rim Charter Public (District) |
| 3rd row | Acton-Boxborough |
| 4th row | Advanced Math and Science Academy Charter (District) |
| 5th row | Agawam |
| Value | Count | Frequency (%) |
| district | 34 | 6.2% |
| regional | 28 | 5.1% |
| charter | 27 | 5.0% |
| vocational | 22 | 4.0% |
| technical | 21 | 3.9% |
| school | 16 | 2.9% |
| academy | 10 | 1.8% |
| public | 7 | 1.3% |
| north | 7 | 1.3% |
| of | 6 | 1.1% |
| Other values (304) | 367 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 380 | 8.4% |
| o | 350 | 7.7% |
| a | 327 | 7.2% |
| t | 317 | 7.0% |
| r | 306 | 6.7% |
| i | 289 | 6.4% |
| n | 271 | 6.0% |
| 269 | 5.9% | |
| l | 261 | 5.7% |
| c | 189 | 4.2% |
| Other values (45) | 1588 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3616 | |
| Uppercase Letter | 576 | 12.7% |
| Space Separator | 269 | 5.9% |
| Open Punctuation | 28 | 0.6% |
| Close Punctuation | 28 | 0.6% |
| Dash Punctuation | 27 | 0.6% |
| Other Punctuation | 3 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 380 | |
| o | 350 | |
| a | 327 | |
| t | 317 | |
| r | 306 | |
| i | 289 | 8.0% |
| n | 271 | 7.5% |
| l | 261 | 7.2% |
| c | 189 | 5.2% |
| h | 172 | 4.8% |
| Other values (15) | 754 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 62 | 10.8% |
| C | 57 | 9.9% |
| R | 45 | 7.8% |
| D | 45 | 7.8% |
| M | 37 | 6.4% |
| A | 36 | 6.2% |
| B | 35 | 6.1% |
| W | 33 | 5.7% |
| T | 33 | 5.7% |
| V | 30 | 5.2% |
| Other values (13) | 163 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1 | |
| ' | 1 | |
| . | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 269 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 28 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 28 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 27 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4192 | |
| Common | 355 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 380 | 9.1% |
| o | 350 | 8.3% |
| a | 327 | 7.8% |
| t | 317 | 7.6% |
| r | 306 | 7.3% |
| i | 289 | 6.9% |
| n | 271 | 6.5% |
| l | 261 | 6.2% |
| c | 189 | 4.5% |
| h | 172 | 4.1% |
| Other values (38) | 1330 |
Common
| Value | Count | Frequency (%) |
| 269 | ||
| ( | 28 | 7.9% |
| ) | 28 | 7.9% |
| - | 27 | 7.6% |
| : | 1 | 0.3% |
| ' | 1 | 0.3% |
| . | 1 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4547 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 380 | 8.4% |
| o | 350 | 7.7% |
| a | 327 | 7.2% |
| t | 317 | 7.0% |
| r | 306 | 6.7% |
| i | 289 | 6.4% |
| n | 271 | 6.0% |
| 269 | 5.9% | |
| l | 261 | 5.7% |
| c | 189 | 4.2% |
| Other values (45) | 1588 |
Tests Taken
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 128 |
|---|---|
| Distinct (%) | 46.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 125.98551 |
| Minimum | 0 |
|---|---|
| Maximum | 18046 |
| Zeros | 59 |
| Zeros (%) | 21.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 38.5 |
| Q3 | 79.25 |
| 95-th percentile | 228.5 |
| Maximum | 18046 |
| Range | 18046 |
| Interquartile range (IQR) | 72.25 |
Descriptive statistics
| Standard deviation | 1085.5973 |
|---|---|
| Coefficient of variation (CV) | 8.6168424 |
| Kurtosis | 272.9117 |
| Mean | 125.98551 |
| Median Absolute Deviation (MAD) | 34.5 |
| Skewness | 16.475508 |
| Sum | 34772 |
| Variance | 1178521.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 59 | 21.4% |
| 37 | 5 | 1.8% |
| 15 | 4 | 1.4% |
| 24 | 4 | 1.4% |
| 56 | 4 | 1.4% |
| 59 | 4 | 1.4% |
| 7 | 4 | 1.4% |
| 29 | 3 | 1.1% |
| 31 | 3 | 1.1% |
| 5 | 3 | 1.1% |
| Other values (118) | 183 |
| Value | Count | Frequency (%) |
| 0 | 59 | |
| 2 | 1 | 0.4% |
| 3 | 2 | 0.7% |
| 4 | 1 | 0.4% |
| 5 | 3 | 1.1% |
| 6 | 1 | 0.4% |
| 7 | 4 | 1.4% |
| 8 | 1 | 0.4% |
| 9 | 3 | 1.1% |
| 10 | 2 | 0.7% |
| Value | Count | Frequency (%) |
| 18046 | 1 | |
| 629 | 1 | |
| 559 | 1 | |
| 510 | 1 | |
| 305 | 1 | |
| 275 | 1 | |
| 261 | 1 | |
| 260 | 1 | |
| 249 | 2 | |
| 240 | 2 |
% Score 1-2
Real number (ℝ)
ZEROS
| Distinct | 181 |
|---|---|
| Distinct (%) | 65.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.25747155 |
| Minimum | 0 |
|---|---|
| Maximum | 0.94117647 |
| Zeros | 79 |
| Zeros (%) | 28.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.22855179 |
| Q3 | 0.42953668 |
| 95-th percentile | 0.690625 |
| Maximum | 0.94117647 |
| Range | 0.94117647 |
| Interquartile range (IQR) | 0.42953668 |
Descriptive statistics
| Standard deviation | 0.24489572 |
|---|---|
| Coefficient of variation (CV) | 0.95115642 |
| Kurtosis | -0.52430563 |
| Mean | 0.25747155 |
| Median Absolute Deviation (MAD) | 0.22855179 |
| Skewness | 0.65485936 |
| Sum | 71.062148 |
| Variance | 0.059973913 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 0.5 | 4 | 1.4% |
| 0.375 | 4 | 1.4% |
| 0.6666666667 | 3 | 1.1% |
| 0.3333333333 | 3 | 1.1% |
| 0.25 | 2 | 0.7% |
| 0.2916666667 | 2 | 0.7% |
| 0.6176470588 | 2 | 0.7% |
| 0.4 | 2 | 0.7% |
| 0.2413793103 | 2 | 0.7% |
| Other values (171) | 173 |
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 0.02142857143 | 1 | 0.4% |
| 0.0303030303 | 1 | 0.4% |
| 0.03137254902 | 1 | 0.4% |
| 0.03225806452 | 1 | 0.4% |
| 0.03333333333 | 1 | 0.4% |
| 0.03636363636 | 1 | 0.4% |
| 0.03910614525 | 1 | 0.4% |
| 0.0404040404 | 1 | 0.4% |
| 0.04545454545 | 1 | 0.4% |
| Value | Count | Frequency (%) |
| 0.9411764706 | 1 | |
| 0.9310344828 | 1 | |
| 0.875 | 1 | |
| 0.8709677419 | 1 | |
| 0.8571428571 | 1 | |
| 0.8245614035 | 1 | |
| 0.8157894737 | 1 | |
| 0.8 | 1 | |
| 0.7692307692 | 1 | |
| 0.7272727273 | 1 |
% Score 3-5
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 178 |
|---|---|
| Distinct (%) | 64.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.42231086 |
| Minimum | 0 |
|---|---|
| Maximum | 0.97857143 |
| Zeros | 82 |
| Zeros (%) | 29.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.4710084 |
| Q3 | 0.6936323 |
| 95-th percentile | 0.92651515 |
| Maximum | 0.97857143 |
| Range | 0.97857143 |
| Interquartile range (IQR) | 0.6936323 |
Descriptive statistics
| Standard deviation | 0.33216092 |
|---|---|
| Coefficient of variation (CV) | 0.7865318 |
| Kurtosis | -1.3897515 |
| Mean | 0.42231086 |
| Median Absolute Deviation (MAD) | 0.29782287 |
| Skewness | -0.041269843 |
| Sum | 116.5578 |
| Variance | 0.11033088 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 82 | |
| 0.3333333333 | 6 | 2.2% |
| 0.6666666667 | 6 | 2.2% |
| 0.4285714286 | 2 | 0.7% |
| 0.3636363636 | 2 | 0.7% |
| 0.3529411765 | 2 | 0.7% |
| 0.7083333333 | 2 | 0.7% |
| 0.5 | 2 | 0.7% |
| 0.6333333333 | 2 | 0.7% |
| 0.6111111111 | 2 | 0.7% |
| Other values (168) | 168 |
| Value | Count | Frequency (%) |
| 0 | 82 | |
| 0.03448275862 | 1 | 0.4% |
| 0.06666666667 | 1 | 0.4% |
| 0.09677419355 | 1 | 0.4% |
| 0.15 | 1 | 0.4% |
| 0.1754385965 | 1 | 0.4% |
| 0.1842105263 | 1 | 0.4% |
| 0.1875 | 1 | 0.4% |
| 0.1904761905 | 1 | 0.4% |
| 0.2051282051 | 1 | 0.4% |
| Value | Count | Frequency (%) |
| 0.9785714286 | 1 | |
| 0.9696969697 | 1 | |
| 0.968627451 | 1 | |
| 0.9677419355 | 1 | |
| 0.9636363636 | 1 | |
| 0.9608938547 | 1 | |
| 0.9595959596 | 1 | |
| 0.9466666667 | 1 | |
| 0.9416666667 | 1 | |
| 0.9380530973 | 1 |
| District Code | All Grades | Total Students | Primary | Secondary | High | Others-% | Tests Taken | % Score 1-2 | % Score 3-5 | |
|---|---|---|---|---|---|---|---|---|---|---|
| District Code | 1.000 | -0.354 | -0.433 | -0.148 | -0.361 | -0.122 | -0.254 | -0.285 | -0.151 | -0.266 |
| All Grades | -0.354 | 1.000 | 0.549 | 0.606 | 0.940 | 0.383 | 0.879 | 0.370 | 0.167 | 0.321 |
| Total Students | -0.433 | 0.549 | 1.000 | 0.102 | 0.550 | 0.418 | 0.186 | 0.723 | 0.325 | 0.569 |
| Primary | -0.148 | 0.606 | 0.102 | 1.000 | 0.426 | 0.024 | 0.708 | -0.022 | 0.089 | -0.045 |
| Secondary | -0.361 | 0.940 | 0.550 | 0.426 | 1.000 | 0.290 | 0.780 | 0.373 | 0.161 | 0.327 |
| High | -0.122 | 0.383 | 0.418 | 0.024 | 0.290 | 1.000 | 0.247 | 0.347 | 0.105 | 0.241 |
| Others-% | -0.254 | 0.879 | 0.186 | 0.708 | 0.780 | 0.247 | 1.000 | 0.103 | 0.084 | 0.118 |
| Tests Taken | -0.285 | 0.370 | 0.723 | -0.022 | 0.373 | 0.347 | 0.103 | 1.000 | 0.448 | 0.842 |
| % Score 1-2 | -0.151 | 0.167 | 0.325 | 0.089 | 0.161 | 0.105 | 0.084 | 0.448 | 1.000 | 0.252 |
| % Score 3-5 | -0.266 | 0.321 | 0.569 | -0.045 | 0.327 | 0.241 | 0.118 | 0.842 | 0.252 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| District Name_x | District Code | All Grades | Total Students | Primary | Secondary | High | Others-% | District Name_y | Tests Taken | % Score 1-2 | % Score 3-5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Abington | 10000 | 259.0 | 1658.0 | 0.0 | 259.0 | 0.0 | 15.621230 | Abington | 25.0 | 0.160000 | 0.680000 |
| 1 | Academy Of the Pacific Rim Charter Public (District) | 4120000 | 0.0 | 36.0 | 0.0 | 0.0 | 0.0 | 0.000000 | Academy Of the Pacific Rim Charter Public (District) | 0.0 | 0.000000 | 0.000000 |
| 2 | Acton-Boxborough | 6000000 | 722.0 | 4322.0 | 0.0 | 686.0 | 36.0 | 16.705229 | Acton-Boxborough | 305.0 | 0.062295 | 0.937705 |
| 3 | Advanced Math and Science Academy Charter (District) | 4300000 | 315.0 | 808.0 | 0.0 | 225.0 | 90.0 | 38.985149 | Advanced Math and Science Academy Charter (District) | 135.0 | 0.111111 | 0.888889 |
| 4 | Agawam | 50000 | 883.0 | 2789.0 | 0.0 | 867.0 | 16.0 | 31.660093 | Agawam | 37.0 | 0.432432 | 0.459459 |
| 5 | Amesbury | 70000 | 773.0 | 1481.0 | 310.0 | 407.0 | 56.0 | 52.194463 | Amesbury | 0.0 | 0.000000 | 0.000000 |
| 6 | Amherst-Pelham | 6050000 | 34.0 | 849.0 | 0.0 | 0.0 | 34.0 | 4.004711 | Amherst-Pelham | 73.0 | 0.123288 | 0.876712 |
| 7 | Andover | 90000 | 1203.0 | 4549.0 | 0.0 | 1142.0 | 61.0 | 26.445373 | Andover | 140.0 | 0.021429 | 0.978571 |
| 8 | Arlington | 100000 | 317.0 | 4818.0 | 0.0 | 317.0 | 0.0 | 6.579494 | Arlington | 240.0 | 0.158333 | 0.841667 |
| 9 | Ashburnham-Westminster | 6100000 | 505.0 | 1981.0 | 0.0 | 493.0 | 12.0 | 25.492176 | Ashburnham-Westminster | 20.0 | 0.700000 | 0.250000 |
| District Name_x | District Code | All Grades | Total Students | Primary | Secondary | High | Others-% | District Name_y | Tests Taken | % Score 1-2 | % Score 3-5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 266 | Weymouth | 3360000 | 34.0 | 4058.0 | 0.0 | 0.0 | 34.0 | 0.837851 | Weymouth | 92.0 | 0.532609 | 0.467391 |
| 267 | Whitman-Hanson | 7800000 | 6.0 | 2956.0 | 0.0 | 0.0 | 6.0 | 0.202977 | Whitman-Hanson | 38.0 | 0.500000 | 0.447368 |
| 268 | Whittier Regional Vocational Technical | 8850000 | 0.0 | 847.0 | 0.0 | 0.0 | 0.0 | 0.000000 | Whittier Regional Vocational Technical | 10.0 | 0.000000 | 0.000000 |
| 269 | Wilmington | 3420000 | 1769.0 | 2456.0 | 787.0 | 950.0 | 32.0 | 72.027687 | Wilmington | 85.0 | 0.529412 | 0.470588 |
| 270 | Winchendon | 3430000 | 318.0 | 970.0 | 246.0 | 72.0 | 0.0 | 32.783505 | Winchendon | 0.0 | 0.000000 | 0.000000 |
| 271 | Winchester | 3440000 | 71.0 | 3807.0 | 0.0 | 0.0 | 71.0 | 1.864986 | Winchester | 249.0 | 0.092369 | 0.907631 |
| 272 | Winthrop | 3460000 | 688.0 | 1487.0 | 468.0 | 220.0 | 0.0 | 46.267653 | Winthrop | 63.0 | 0.682540 | 0.301587 |
| 273 | Woburn | 3470000 | 614.0 | 3113.0 | 0.0 | 592.0 | 22.0 | 19.723739 | Woburn | 45.0 | 0.511111 | 0.488889 |
| 274 | Worcester | 3480000 | 322.0 | 7797.0 | 0.0 | 284.0 | 38.0 | 4.129794 | Worcester | 275.0 | 0.552727 | 0.447273 |
| 275 | State Totals | 0 | 121772.0 | 557504.0 | 35619.0 | 81769.0 | 4384.0 | 21.842354 | State Totals | 18046.0 | 0.302394 | 0.697606 |